🕷️️ Job Radar • SCRAPING

freelancer.com 2026-04-27 🟢

🔹 Inspect and Price Auto Repair Components from High-Resolution Photos
👤 Client: 🇺🇸 SACRAMENTO, United States Member since 2019-04-15
💰 Price: $35 Average bid
🚩 Problem: Accurately identify reusable and damaged components in a 2025 Rivian R1S and provide pricing for replacements.
📦 Existing: Not specified

Specifications:

[Target] - Excel workbook with detailed component analysis and pricing
[Method] - Image analysis, web scraping, data entry, and formatting
[UI/UX] - Clean, organized tab structure; color-coded rows; active links
[Stack] - Python (Pandas for data manipulation), OpenCV or similar library for image processing, Excel VBA for automation
[Security] - Data privacy compliance, secure storage of sensitive information
[Format] - Tab-separated workbook with clear headers and consistent formatting

Workflow:

Receive high-resolution photos from the client.
Analyze images to identify visible components, marking reusable (GREEN) and damaged (RED).
For each damaged component: find the exact Rivian part name and official part number.
Locate and document the lowest-priced new and used replacement options from major U.S. sites such as eBay Motors, [login to view URL], LKQ, etc.
Capture key specs (condition, seller, shipping, warranty) for each source.
Create an Excel workbook with separate tabs for exterior and interior sections.
Color code rows based on component status (GREEN or RED).
Add links to direct URLs of sources in the respective price columns.
Insert image call-outs using simple arrows or circled highlights, ensuring they correspond line-for-line with the sheet.
Test workbook for errors and ensure all components are accounted for.